/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : tea

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 04/02/2023 07:28:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `goods_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `total` int DEFAULT NULL,
  `order_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `order_status` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for shopCart
-- ----------------------------
DROP TABLE IF EXISTS `shopCart`;
CREATE TABLE `shopCart` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `goods_name` varchar(255) DEFAULT NULL,
  `goods_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `goods_price` varchar(255) DEFAULT NULL,
  `goods_choose` varchar(255) DEFAULT NULL,
  `goods_img` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of shopCart
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` text NOT NULL,
  `phone` text NOT NULL,
  `address` text NOT NULL,
  `orderInfo` text NOT NULL,
  `integral` text NOT NULL,
  `gender` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `phone`, `address`, `orderInfo`, `integral`, `gender`) VALUES (1, 'admin', '123', '123456', '资阳市 ', '无 ', '520', '男');
INSERT INTO `user` (`id`, `username`, `password`, `phone`, `address`, `orderInfo`, `integral`, `gender`) VALUES (9, '芝士汉堡火鸡面哈哈哈哈哈', '123', '15583251761', '[{\"address\":\"四川省资阳市雁江区狮子山小区\",\"nick\":\"xiaotian\",\"phone\":\"15583251761\",\"default\":false,\"id\":9},{\"address\":\"安徽省合肥市包河区安徽工业经济职业技术学院\",\"nick\":\"wifi\",\"phone\":\"15583251761\",\"default\":true,\"id\":9}]', '', '0', '男');
INSERT INTO `user` (`id`, `username`, `password`, `phone`, `address`, `orderInfo`, `integral`, `gender`) VALUES (10, '小天', '123', '15583251761', '四川省资阳市雁江区', '', '0', '男');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
